Calendar Dates dimension

The Calendar Dates dimension ensures referential integrity for core data tables that are period based or other data driven attributes, e.g., admission date for a patient in Axiom Enterprise Decision Support. This forces valid dates in an integer format are loaded into the system and can be cross referenced across the various tables and processes.

It is also used as a means of managing the relationship between a calendar date and the fiscal equivalent. The fiscal equivalent of the calendar date can used by data processing and also be presented back to the user in reporting.

TIP: You can manage your dimension tables by downloading them in spreadsheet form so that you can make larger changes more easily. You can then upload the spreadsheet with the changes back into the system. For more information, see Editing a dimension using a spreadsheet.

Accessing the Calendar Dates dimension

From the Enterprise Decision Support home page, in the Data Control section, click Data Management > Core Dimensions > Calendar Dates.

Click image to view full size

The page can only display up to a maximum of 10,000 records.

NOTE: At this time, you can only add records in this dimension table directly through Axiom Explorer > Table Library > !Dimensions > CALDATE in the Windows or Excel Client. For more information, see Opening dimension tables in spreadsheet mode.

Editing a date

Due to the large number of records that this table may contain, you need to use the Filter panel to identify the records to display.

To edit a date:

  1. In the table, click in the cell(s) to edit, make your changes.

    NOTE: Columns that are grayed out cannot be edited.

  2. Click Save.

Deleting a date

Due to the large number of records that this table may contain, you need to use the Filter panel to identify the records to display.

To delete a date:

  1. In the table, select the row to highlight it, and then click Delete Row.
  2. At the Continue? prompt, click OK.
  3. When you finish making changes, click Save.

Column descriptions

This section provides descriptions for each column in the Calendar Dates dimension table:

NOTE: The table may display some columns that are related to other Syntellis products or have been created specifically for your organization. Contact your Syntellis Implementation Consultant or Syntellis Support if you need help with these columns.

Keys

Every table in the database must have at least one key column. Key columns define unique records of data in the table. If a table has one key column, then each value in that key column must be unique and defines a unique record in the table. If a table has multiple key columns, then each combination of values in those key columns defines a unique record in the table.

CALDATE - The day of the year used for each record in the Daily Productivity table. The values must be an Integer and created as YYYYMMDD (ex. 20171231).

Description - The description can be the long form of the date such as December 31, 2017.

TIP: To help make reports more readable, we recommend that you do not use all capital letters in the description content.